Release 10.1A: OpenEdge Data Management:
Database Administration

Table and index limits

You cannot split a table or an index across storage areas. Each table and each index can be assigned to only one storage area. Therefore, the size of a table or index is limited to the size of the storage area in which it resides (see Table 2–2).

Regardless of block size, the maximum number of tables supported is 32,767.

Tables have a maximum number of fields: SQL supports 500, the 4GL supports 1000.

Regardless of block size, the maximum number of indexes supported is 32,767.

Index entries have a maximum of 16 fields per index. Total variable-length storage requirements of all fields in an index entry must be less than 200 characters.

Note: Because the 200 character limit includes storage overhead, the actual index key is limited to approximately 188 characters.